How to: Add the fields needed for a query to the design (QBE) grid.
Solution:
Drag the field from a table's field list in the top half of the Query Design window to the desired column of the design grid in the bottom half of the Query Design window.
Design grid
1) Make sure the Query Design view is open:
a) If the Database window is not active, activate the Database window.
b) Click the 'Queries' tab in the Database window.
Queries tab
c) Do one of the following:
1] To create a new query:
a] Click 'New'. (The New Query dialog box appears.)
b] Select 'Design View' from the list box.
c] Click 'OK'. (The query opens in Design view, and the Show Table dialog box appears.)
d] Do one of the following:
1} Click the 'Tables' tab to display a list of tables only.
2} Click the 'Queries' tab to display a list of queries only.
3} Click the 'Both' tab to display a list of both tables and queries.
e] Select the table(s) and/or querie(s) to include in the query from the list box.
NOTE: To select more than one adjacent table or query, press and hold down SHIFT while selecting the tables or queries. To select more than one non-adjacent table or query, press and hold down CTRL while selecting the tables or queries.
f] Click 'Add'.
g] Click 'Close' when all of the desired tables and/or queries have been added.
2] To add fields to the design grid for an existing query, click 'Design'. (The query opens in the Query Design view.)
2) Select a field from a table's field list in the top half of the Query Design window.
3) Drag the field to the desired column of the design grid in the bottom half of the Query Design window.
Design grid
4) Release the mouse button. (The field name appears in the Field row, and its table appears in the Table row.)
Field row and Table row
5) Repeat steps 2) through 4) for each field to add to the query.
NOTE: Fields can also be added to the query by selecting a field from the drop-down list box in the 'Field' row of the design grid in the bottom half of the Query Design window.
Design grid
6) To save the query:
a) Select the 'File' menu and select 'Save'. (If the query is an existing query, the query is saved. If the query is a new query, the Save As dialog box appears.)
b) If the 'Save As' dialog box appears, type a name for the action query in the 'Query Name' box.
c) Click 'OK'.
7) Select the 'File' menu and select 'Close' to close the Query Design view.
